sp_helpfile
go
use RD_PayrollMart
ALTER DATABASE RD_PayrollMart 
SET offline 
GO
ALTER DATABASE RD_PayrollMart 
MODIFY FILE ( NAME = RD_PayrollMart, FILENAME = 'K:\Database Files\RD_PayrollMart.mdf'
) 
ALTER DATABASE RD_PayrollMart 
MODIFY FILE ( NAME = RD_PayrollMart_2, FILENAME = 'K:\Database Files\RD_PayrollMart_2.ndf'
)

ALTER DATABASE RD_PayrollMart 
MODIFY FILE ( NAME = RD_PayrollMart_3, FILENAME = 'K:\Database Files\RD_PayrollMart_3.ndf'
) 

ALTER DATABASE RD_PayrollMart 
MODIFY FILE ( NAME = RD_PayrollMart_4, FILENAME = 'K:\Database Files\RD_PayrollMart_4.ndf'
) 
/***
run it after move the file from the old location to the new location
ALTER DATABASE RD_PayrollMart 
SET online 
GO
sp_helpfile
go
**/